This document describes how to perform periodic maintenance on WMS tables, to help limit your database size.
When using E-WMS (and ICL) some tables could contain a considerable number of records, and could be cleaned up periodically.
This table contains all messages generated by the E-WMS (or ICL) services and recent actions within the control centers. Probably you do not need history for more than for example 30 days. In that case you could schedule in a SQL job a query to run each night: DELETE FROM csPickitErrorReport WHERE syscreated < GETDATE()-30That will delete all records older than 30 days. When executing the first time, this can take considerable time and strain on the SQL server ! Starting from product update 405, the services handle the generation of error message more efficiently. Both E-WMS and Intercompany Logistics (ICL) use this table.
This table contains a log of all actions performed within control centers and on the hand terminals. You could for instance measure order picker productivity from the data in this table. If you do not need this data, or only for a limited period, you can use the same method as described above (for csPickitErrorReport) to delete old records periodically.
DELETE FROM csPickitStatistics WHERE syscreated < GETDATE()-30
When using E-WMS ASP each screen and input on the hand terminals was, until product update 402, automatically logged into three session log tables, so these sessions could be replayed using the 'WMS Management tool'. This management screen only shows session information from Internet Explorer client sessions. When you do not need this session history, you can periodically clean up these session log tables. This sample deletes history older than 30 days: delete CSPickItWebFormFields from CSPickItWebFormFields c join CSPickItWebRequests b on c.WebRequestID=b.ID join CSPickItWebSessions a on b.WebSessionID=a.ID where a.[DateTime] < GETDATE()-30 delete CSPickItWebRequests from CSPickItWebRequests b join CSPickItWebSessions a on b.WebSessionID=a.ID where a.[DateTime] < GETDATE()-30 delete from CSPickItWebSessions where [DateTime] < GETDATE()-30
When performing this clean-up the first time, this can take considerable time and strain on the SQL server.